General Report

From

Inventory In

prepare("select * from inventory_main where date_in BETWEEN '$date1' and '$date2'") ; $getd->execute() ; while($row = $getd->fetch(pdo::FETCH_ASSOC)) { $tcost[] = $row['gross_total'] ; $sales[] = $row['invent_id'] ; //$salesdept[] = $row['sales_dept'] ; } ?> prepare("select * from invent_details where invent_id = '$sid'") ; $gd->execute() ; while($row1=$gd->fetch(pdo::FETCH_ASSOC)) { $ctx++ ; //$sd = $salesdept[$x] ; ?>

SN	INVENT ID	CATEGORY	ITEMS	MEASURE	QUANTITY	UNIT-COST	TOTAL-COST

						Grand Total

Inventory out

prepare("select * from outmain where dateout BETWEEN '$date1' and '$date2'") ; $getd->execute() ; while($row = $getd->fetch(pdo::FETCH_ASSOC)) { //$tcost[] = $row['amount'] ; $sales[] = $row['inventout_id'] ; $salesdept[] = $row['department'] ; } ?>

prepare("select * from outdetails where inventout_id = '$sid'") ; $gd->execute() ; while($row1=$gd->fetch(pdo::FETCH_ASSOC)) { $ct++ ; $sd = $salesdept[$x] ; ?>

SN	INVENTOUT ID	CATEGORY	ITEMS	MEASURE	QUANTITY

Inventory Transfer

prepare("select * from transfer_main where tranfer_date BETWEEN '$date1' and '$date2'") ; $getd->execute() ; while($row = $getd->fetch(pdo::FETCH_ASSOC)) { //$tcost[] = $row['amount'] ; $tsales[] = $row['transfer_id'] ; $release[] = $row['release_dept'] ; $receive[] = $row['receiving_dept'] ; } ?>

prepare("select * from transfer_details where transfer_id = '$sid'") ; $gd->execute() ; while($row1=$gd->fetch(pdo::FETCH_ASSOC)) { $ctf++ ; $sd = $release[$x] ; $sdx = $receive[$x] ; ?>

SN	TRANSFER ID	CATEGORY	ITEMS	MEASURE	QUANTITY

Sales Report

prepare("select * from salesmain where (sales_date BETWEEN '$date1' and '$date2') ") ; $getd->execute() ; while($row = $getd->fetch(pdo::FETCH_ASSOC)) { $tcostx[] = $row['amount'] ; $salesx[] = $row['sales_id'] ; $salesdeptx[] = $row['sales_dept'] ; } ?>

prepare("select * from salesdetails where sales_id = '$sid'") ; $gd->execute() ; while($row1=$gd->fetch(pdo::FETCH_ASSOC)) { $ctz++ ; $sd = $salesdeptx[$x] ; ?>

SN	SALES ID	CATEGORY	ITEMS	QUANTITY	UNIT-COST	TOTAL-COST

					Grand Total

Sales (BBQ, SHAWARMA, SUYA SPOT, SWIMMING, SNOKER, KITCHEN)

prepare("select * from extrasales where sdate BETWEEN '$date1' and '$date2' ") ; $getrecxs->execute() ; //get sum $gsumxs = $DBcon->prepare("select sum(amount) as sgcost from extrasales where sdate BETWEEN '$date1' and '$date2' ") ; $gsumxs->execute() ; $gsrowxs = $gsumxs->fetch(pdo::FETCH_ASSOC) ; $tsumxs = $gsrowxs['sgcost'] ; $countxs = 0 ; while($rows = $getrecxs->fetch(pdo::FETCH_ASSOC)) { $countxs++ ; ?>

SN	DATE	DEPARTMENT	ITEM	AMOUNT

			Grand Total

Room Bookings

prepare("select * from booking_table where bk_date BETWEEN '$date1' and '$date2' ") ; $getrec->execute() ; //get sum $gsum = $DBcon->prepare("select sum(T_cost) as gcost from booking_table where bk_date BETWEEN '$date1' and '$date2' ") ; $gsum->execute() ; $gsrow = $gsum->fetch(pdo::FETCH_ASSOC) ; $tsum = $gsrow['gcost'] ; $count = 0 ; while($row = $getrec->fetch(pdo::FETCH_ASSOC)) { $count++ ; ?>

SN	BOOKING-ID	CUSTOMER	ROOM NO	CHECK-IN	CHECK-OUT	GUEST NO	AMOUNT

						Grand Total

Expensis Report

prepare("select * from expensis where expdate BETWEEN '$date1' and '$date2' ") ; $getrecx->execute() ; //get sum $gsumx = $DBcon->prepare("select sum(amount) as expgcost from expensis where expdate BETWEEN '$date1' and '$date2' ") ; $gsumx->execute() ; $gsrowx = $gsumx->fetch(pdo::FETCH_ASSOC) ; $tsumx = $gsrowx['expgcost'] ; $countx = 0 ; while($row = $getrecx->fetch(pdo::FETCH_ASSOC)) { $countx++ ; ?>

SN	EXPENSIS DATE	DEPARTMENT	AMOUNT	PURPOSE

			Grand Total

PayRoll Report

prepare("select * from payroll") ; $getall->execute() ; $count = 0 ; $gsa = array() ; $nets = array() ; $txarray = array() ; while($row = $getall->fetch(pdo::FETCH_ASSOC)) { $count++ ; ?> prepare("select * from staff_table where staff_id_no =:a") ; $stname->bindparam(":a",$stf) ; $stname->execute() ; $rname = $stname->fetch(pdo::FETCH_ASSOC) ; $staffname = $rname['names'] ; ?>

STAFF_ID

STAFF NAME

POSITION

TAX

NET SALARY

prepare("select * from deductions where ((staff_id = '$stf' and deduction = 'LD') and (pyear='$dy' and pmonth='$dm'))") ; $loan->execute() ; if($loan->rowcount() > 0) { $lrow = $loan->fetch(pdo::FETCH_ASSOC) ; $lds =$lrow['amount'] ; } else { $lds = 0 ; } echo $lds ; ?>

prepare("select * from deductions where ((staff_id = '$stf' and deduction = 'SA') and (pyear='$dy' and pmonth='$dm'))") ; $sad->execute() ; if($sad->rowcount() > 0) { $lrows = $sad->fetch(pdo::FETCH_ASSOC) ; $sads =$lrows['amount'] ; } else { $sads = 0 ; } echo $sads ; ?>

prepare("select * from deductions where ((staff_id = '$stf' and deduction = 'OD') and (pyear='$dy' and pmonth='$dm'))") ; $odd->execute() ; if($odd->rowcount() > 0) { $orow = $odd->fetch(pdo::FETCH_ASSOC) ; $oddn =$orow['amount'] ; } else { $oddn = 0 ; } echo $oddn ; ?>

Total Gross :N

Total Tax :N

Total NS :N

Summary

SN	DEPARTMENT	INCOME	EXPENDITURES

Dashboard